Skip to main content

utl_file I/O

Short Description

Waits associated with operations performed using the UTL_FILE package.

Detailed Description​

With the UTL_FILE package, PL/SQL programs can read and write operating system files. UTL_FILE provides a restricted version of operating system file I/O.

How to reduce this wait​

The possible locations that files are accessible in are listed in the ALL_DIRECTORIES view.

Ensure there is no contention on the underlying O/S filesystem.

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.